Records what columns to sort, and whether to sort in ascending or descending order. (This Registry entry is generated and maintained by the System when a Sort is defined in a module).
Description
Users can create and save their own set of rules used for sorting data. The Sort Registry entry records which columns to sort, and whether to sort in ascending or descending order. A user can choose which Sort definition to use from the Sort box by selecting Sort on the Home tab of the Ribbon.
The currently selected Sort for a user is recorded in the Sort Selected Registry entry.
Usage
This Registry entry can be assigned to users and groups:
| Key | User | Group | Group |
|---|---|---|---|
| Key 1 | User
|
Group
|
Group
|
| Key 2 | user | group | Default
|
| Key 3 | Table
|
||
| Key 4 | table | ||
| Key 5 | Sort
|
||
| Key 6 | title | ||
| Value | rules | ||
In pipe-delimited format:
User
|
user | Table
|
table | Sort
|
title | rules |
Group
|
group | Table
|
table | Sort
|
title | rules |
Group
|
Default
|
Table
|
table | Sort
|
title | rules |
where:
|
title |
is a name for the Sort. It displays in the Sort box when listing all defined Sort entries available to a user. |
|
rules |
is in the format: xcolumn;xcolumn;... where the value for x is either + or - indicating an ascending or descending ordered sort respectively; column is the name of a back-end field. |
The records will be sorted on the first column, and any records with the same value in the first column will be sorted by the second column, and so on.
Example
This entry specifies a Sort for user gerard in the Parties module. The entry defines an ascending sort on the AddPhysCity field, with a secondary descending order sort on the AddPhysState field:
| Key | Setting |
|---|---|
| Key 1 | User
|
| Key 2 | gerard
|
| Key 3 | Table
|
| Key 4 | eparties
|
| Key 5 | Sort
|
| Key 6 | Address
|
| Value | +AddPhysCity;-AddPhysState
|
